<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
 *
 * @version $Id: db_datadict.php 11334 2008-06-21 13:16:05Z lem9 $
 */

/**
 * Gets the variables sent or posted to this script, then displays headers
 */
require_once './libraries/common.inc.php';

if (!isset($selected_tbl)) {
	require_once './libraries/header.inc.php';
}


/**
 * Gets the relations settings
 */
require_once './libraries/relation.lib.php';
require_once './libraries/transformations.lib.php';

$cfgRelation  = PMA_getRelationsParam();

/**
 * Check parameters
 */
PMA_checkParameters(array('db'));

/**
 * Defines the url to return to in case of error in a sql statement
 */
if (strlen($table)) {
	$err_url = 'tbl_sql.php?' . PMA_generate_common_url($db, $table);
} else {
	$err_url = 'db_sql.php?' . PMA_generate_common_url($db);
}

if ($cfgRelation['commwork']) {
	$comment = PMA_getComments($db);

	/**
	 * Displays DB comment
	 */
	if (is_array($comment)) {
		?>
	<p> <?php echo $strDBComment; ?>
		<i><?php echo htmlspecialchars(implode(' ', $comment)); ?></i></p>
		<?php
	} // end if
}

/**
 * Selects the database and gets tables names
 */
PMA_DBI_select_db($db);
$rowset = PMA_DBI_query('SHOW TABLES FROM ' . PMA_backquote($db) . ';', null, PMA_DBI_QUERY_STORE);

$count  = 0;
while ($row = PMA_DBI_fetch_assoc($rowset)) {
	$myfieldname = 'Tables_in_' . htmlspecialchars($db);
	$table		= $row[$myfieldname];
	if ($cfgRelation['commwork'] || PMA_MYSQL_INT_VERSION >= 40100) {
		$comments = PMA_getComments($db, $table);
	}

	if ($count != 0) {
		echo '<div style="page-break-before: always;">' . "\n";
	} else {
		echo '<div>' . "\n";
	}

	echo '<h2>' . $table . '</h2>' . "\n";

	/**
	 * Gets table informations
	 */
	// The 'show table' statement works correct since 3.23.03
	$showtable	= PMA_DBI_get_tables_full($db, $table);
	$num_rows	 = (isset($showtable[$table]['TABLE_ROWS']) ? $showtable[$table]['TABLE_ROWS'] : 0);
	$show_comment = (isset($showtable[$table]['TABLE_COMMENT']) ? $showtable[$table]['TABLE_COMMENT'] : '');
	unset($showtable);


	/**
	 * Gets table keys and retains them
	 */

	PMA_DBI_select_db($db);
	$result	   = PMA_DBI_query('SHOW KEYS FROM ' . PMA_backquote($table) . ';');
	$primary	  = '';
	$indexes	  = array();
	$lastIndex	= '';
	$indexes_info = array();
	$indexes_data = array();
	$pk_array	 = array(); // will be use to emphasis prim. keys in the table
							 // view
	while ($row = PMA_DBI_fetch_assoc($result)) {
		// Backups the list of primary keys
		if ($row['Key_name'] == 'PRIMARY') {
			$primary   .= $row['Column_name'] . ', ';
			$pk_array[$row['Column_name']] = 1;
		}
		// Retains keys informations
		if ($row['Key_name'] != $lastIndex){
			$indexes[] = $row['Key_name'];
			$lastIndex = $row['Key_name'];
		}
		$indexes_info[$row['Key_name']]['Sequences'][]	 = $row['Seq_in_index'];
		$indexes_info[$row['Key_name']]['Non_unique']	  = $row['Non_unique'];
		if (isset($row['Cardinality'])) {
			$indexes_info[$row['Key_name']]['Cardinality'] = $row['Cardinality'];
		}
		// I don't know what does following column mean....
		// $indexes_info[$row['Key_name']]['Packed']		  = $row['Packed'];

		$indexes_info[$row['Key_name']]['Comment']	 = $row['Comment'];

		$indexes_data[$row['Key_name']][$row['Seq_in_index']]['Column_name']  = $row['Column_name'];
		if (isset($row['Sub_part'])) {
			$indexes_data[$row['Key_name']][$row['Seq_in_index']]['Sub_part'] = $row['Sub_part'];
		}

	} // end while
	if ($result) {
		PMA_DBI_free_result($result);
	}


	/**
	 * Gets fields properties
	 */
	$result	  = PMA_DBI_query('SHOW FIELDS FROM ' . PMA_backquote($table) . ';', null, PMA_DBI_QUERY_STORE);
	$fields_cnt  = PMA_DBI_num_rows($result);


// We need this to correctly learn if a TIMESTAMP is NOT NULL, since
// SHOW FULL FIELDS or INFORMATION_SCHEMA incorrectly says NULL
// and SHOW CREATE TABLE says NOT NULL (tested
// in MySQL 4.0.25 and 5.0.21, http://bugs.mysql.com/20910).

	$show_create_table = PMA_DBI_fetch_value(
		'SHOW CREATE TABLE ' . PMA_backquote($db) . '.' . PMA_backquote($table),
		0, 1);
	$analyzed_sql = PMA_SQP_analyze(PMA_SQP_parse($show_create_table));

	// Check if we can use Relations (Mike Beck)
	if (!empty($cfgRelation['relation'])) {
		// Find which tables are related with the current one and write it in
		// an array
		$res_rel = PMA_getForeigners($db, $table);

		if (count($res_rel) > 0) {
			$have_rel = TRUE;
		} else {
			$have_rel = FALSE;
		}
	} else {
		$have_rel = FALSE;
	} // end if


	/**
	 * Displays the comments of the table if MySQL >= 3.23
	 */
	if (!empty($show_comment)) {
		echo $strTableComments . ': ' . htmlspecialchars($show_comment) . '<br /><br />';
	}

	/**
	 * Displays the table structure
	 */
	?>

<table width="100%" class="print">
<tr><th width="50"><?php echo $strField; ?></th>
	<th width="80"><?php echo $strType; ?></th>
<?php /*	<th width="50"><?php echo $strAttr; ?></th>*/ ?>
	<th width="40"><?php echo $strNull; ?></th>
	<th width="70"><?php echo $strDefault; ?></th>
<?php /*	<th width="50"><?php echo $strExtra; ?></th>*/ ?>
	<?php
	if ($have_rel) {
		echo '	<th>' . $strLinksTo . '</th>' . "\n";
	}
	if ($cfgRelation['commwork'] || PMA_MYSQL_INT_VERSION >= 40100) {
		echo '	<th>' . $strComments . '</th>' . "\n";
	}
	if ($cfgRelation['mimework']) {
		echo '	<th>MIME</th>' . "\n";
	}
	?>
</tr>
	<?php
	$odd_row = true;
	while ($row = PMA_DBI_fetch_assoc($result)) {

		$type			 = $row['Type'];
		// reformat mysql query output - staybyte - 9. June 2001
		// loic1: set or enum types: slashes single quotes inside options
		if (preg_match('@^(set|enum)\((.+)\)$@i', $type, $tmp)) {
			$tmp[2]	   = substr(preg_replace('@([^,])\'\'@', '\\1\\\'', ',' . $tmp[2]), 1);
			$type		 = $tmp[1] . '(' . str_replace(',', ', ', $tmp[2]) . ')';
			$type_nowrap  = '';

			$binary	   = 0;
			$unsigned	 = 0;
			$zerofill	 = 0;
		} else {
			$binary	   = stristr($row['Type'], 'binary');
			$unsigned	 = stristr($row['Type'], 'unsigned');
			$zerofill	 = stristr($row['Type'], 'zerofill');
			$type_nowrap  = ' nowrap="nowrap"';
			$type		 = preg_replace('@BINARY@i', '', $type);
			$type		 = preg_replace('@ZEROFILL@i', '', $type);
			$type		 = preg_replace('@UNSIGNED@i', '', $type);
			if (empty($type)) {
				$type	 = ' ';
			}
		}
		$strAttribute	 = ' ';
		if ($binary) {
			$strAttribute = 'BINARY';
		}
		if ($unsigned) {
			$strAttribute = 'UNSIGNED';
		}
		if ($zerofill) {
			$strAttribute = 'UNSIGNED ZEROFILL';
		}
		if (!isset($row['Default'])) {
			if ($row['Null'] != '' && $row['Null'] != 'NO') {
				$row['Default'] = '<i>NULL</i>';
			}
		} else {
			$row['Default'] = htmlspecialchars($row['Default']);
		}
		$field_name = htmlspecialchars($row['Field']);

		// here, we have a TIMESTAMP that SHOW FULL FIELDS reports as having the
		// NULL attribute, but SHOW CREATE TABLE says the contrary. Believe
		// the latter.
		/**
		 * @todo merge this logic with the one in tbl_structure.php
		 * or move it in a function similar to PMA_DBI_get_columns_full()
		 * but based on SHOW CREATE TABLE because information_schema
		 * cannot be trusted in this case (MySQL bug)
		 */
		if (!empty($analyzed_sql[0]['create_table_fields'][$field_name]['type']) && $analyzed_sql[0]['create_table_fields'][$field_name]['type'] == 'TIMESTAMP' && $analyzed_sql[0]['create_table_fields'][$field_name]['timestamp_not_null']) {
			$row['Null'] = '';
		}
		?>
<tr class="<?php echo $odd_row ? 'odd' : 'even'; $odd_row = ! $odd_row; ?>">
	<td nowrap="nowrap">
		<?php
		if (isset($pk_array[$row['Field']])) {
			echo '<u>' . $field_name . '</u>';
		} else {
			echo $field_name;
		}
		?>
	</td>
	<td<?php echo $type_nowrap; ?> xml:lang="en" dir="ltr"><?php echo $type; ?></td>
<?php /*	<td<?php echo $type_nowrap; ?>><?php echo $strAttribute; ?></td>*/ ?>
	<td><?php echo (($row['Null'] == '' || $row['Null'] == 'NO') ? $strNo : $strYes); ?></td>
	<td nowrap="nowrap"><?php if (isset($row['Default'])) { echo $row['Default']; } ?></td>
<?php /*	<td<?php echo $type_nowrap; ?>><?php echo $row['Extra']; ?></td>*/ ?>
		<?php
		if ($have_rel) {
			echo '	<td>';
			if (isset($res_rel[$field_name])) {
				echo htmlspecialchars($res_rel[$field_name]['foreign_table'] . ' -> ' . $res_rel[$field_name]['foreign_field']);
			}
			echo '</td>' . "\n";
		}
		if ($cfgRelation['commwork'] || PMA_MYSQL_INT_VERSION >= 40100) {
			echo '	<td>';
			if (isset($comments[$field_name])) {
				echo htmlspecialchars($comments[$field_name]);
			}
			echo '</td>' . "\n";
		}
		if ($cfgRelation['mimework']) {
			$mime_map = PMA_getMIME($db, $table, true);

			echo '	<td>';
			if (isset($mime_map[$field_name])) {
				echo htmlspecialchars(str_replace('_', '/', $mime_map[$field_name]['mimetype']));
			}
			echo '</td>' . "\n";
		}
		?>
</tr>
		<?php
	} // end while
	PMA_DBI_free_result($result);
	$count++;
	?>
</table>
</div>
	<?php
} //ends main while

/**
 * Displays the footer
 */
?>
<script type="text/javascript">
//<![CDATA[
function printPage()
{
	document.getElementById('print').style.visibility = 'hidden';
	// Do print the page
	if (typeof(window.print) != 'undefined') {
		window.print();
	}
	document.getElementById('print').style.visibility = '';
}
//]]>
</script>
<?php
echo '<br /><br /><input type="button" id="print" value="' . $strPrint . '" onclick="printPage()" />';

require_once './libraries/footer.inc.php';
?>
